home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Business Heaven
/
Business Heaven.iso
/
inventry
/
ii62
/
coldesc.hlp
< prev
next >
Wrap
Text File
|
1993-06-18
|
2KB
|
33 lines
******************************************************************
STATUS.DBF file structure
******************************************************************
NO. Name Description
------------------------------------------------------------------
1 CATAGORY ->the unique catagory name found in the inventory
database file
2 ROWS ->the number of records found in this catagory
3 NO PRICE ->the number of records found to have a cost
of $0.00
4 WITH PRICE ->the number of records in the catagory having a
cost not equal to $0.00
5 SUM PRICE ->the sum of each individual record's cost
6 AVG PRICE ->column NO.5 divided by column NO.4
7 ITEMS ->the sum of On Hand for each record
8 TOT VALUE ->the sum of On Hand X Cost for each record
9 AVG COST ->column NO.8 divided by column NO.7
10 YBL USED ->the quantity of items used 2 years ago
starting Jan 1 to Dec 31
11 YBL COST ->the quantity of each item used 2 years ago X
its current cost
12 LY USED ->the quantity of items used 1 year ago
starting Jan 1 to Dec 31
13 LY COST ->the quantity of each item used 1 year ago X
its current cost
14 TY USED ->the quantity of items used this year since Jan.1
15 TY COST ->the quantity of items used this year since Jan.1
X its current cost
16 TOTAL USED ->the grand total of items used in this Catagory
(including information over 2 years)
17 TOTAL COST ->information of column NO.16 X by its current
cost